The pivot table is an excellent tool in the Excel that helps one in the data analysis. The main objective of a pivot table is to summarize the data. The pivot table sorts, rearranges and groups the variable based on certain criteria. Pivot table can be used in an organization to find the employees drawing the maximum salaries. The organization can also use the pivot table to identify their best selling products. I think one can use the pivot table to get an idea about their monthly budget by identifying the most bought products. For an example, after summing up the budgets into different categories, one can use the pivot table to represent the categories based on the price. The pivot table not only analyses the data in a better way, but also represent them in a more comprehensible form.